package com.sh.fmbackend.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sh.fmbackend.model.domain.Team;
import com.sh.fmbackend.model.domain.UserTeam;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 舒云
* @description 针对表【user_team(用户队伍关系)】的数据库操作Mapper
* @createDate 2024-12-30 21:22:30
* @Entity generator.domain.UserTeam
*/
public interface UserTeamMapper extends BaseMapper<UserTeam> {

    @Select("SELECT * FROM user_team ut WHERE ut.teamId=#{teamId} ORDER BY joinTime ASC limit 2")
    List<UserTeam> getSecondJoinUser(Long teamId);
}




